package com.trkj.dao.jpa;

import java.math.BigDecimal;
import java.util.List;

import org.springframework.data.domain.Pageable;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.CrudRepository;
import com.trkj.pojos.CcOuthospital;

public interface CcOuthospitalDAO extends CrudRepository<CcOuthospital, Long> {

	@Query("select count(*) from CcOuthospital c where c.handleremarks='未处理' and c.outPid=?1")
	public long findByoutPid(BigDecimal outPid);
	@Query("select c from CcOuthospital c order by c.outhodate desc")
	public List<CcOuthospital> queryByAll(Pageable pageable);
}
